Apparatus and method for providing a condition builder interface

ABSTRACT

An apparatus and method for providing a user interface through which a user may generate a conditional expression are provided. The user interface provides guidance to a user as to the proper parts of the conditional expression to include in the conditional expression as the user constructs the conditional expression. Thus, as the user completes parts of the conditional expression, the guidance that is offered is updated based on the current context of the conditional expression. This guidance may include listings of variables, attributes and/or functions that are most appropriate to be entered next in the conditional expression, help text, and the like.

BACKGROUND OF THE INVENTION

1. Technical Field

The present invention is generally directed to an improved dataprocessing system. More specifically, the present invention is directedto an apparatus and method for providing a condition builder interface.

2. Description of Related Art

In many computer applications, there are scenarios where a user has todefine a condition expression. For example, in a mortgage approvalapplication, mortgage approval may be granted for a customer if themonthly mortgage payment is less than 33% of their monthly income. Theseconditional expressions are typically expressed using a computerlanguage which novice users may find difficult to understand and use. Tosimply the creation of these conditional expressions, a number ofdifferent techniques have been developed and adopted by computerapplication providers.

For example, in Microsoft Excel™, a spreadsheet application availablefrom Microsoft Corporation, a condition is defined using a graphicaluser interface having a series of combination boxes as illustrated inFIG. 1A. As shown in FIG. 1A, the conditional expression user interfacefor Microsoft Excel™ includes a first field 110 for entering a parameterupon which the condition operations, a second field 120 for entering thecondition type, and at least one third field 130 for entering parametervalues for the condition.

Different condition types selected via the second field 120 may resultin a different number of parameter value fields 130, as illustrated inFIG. 1B. As shown, rather than two parameter value fields 130 as in the“between” condition type selected in FIG. 1A, the “greater than”condition type selected in field 120 of FIG. 1B results in only a singleparameter value field 130 being provided.

If a condition is not within the bounds of a simple expression list,i.e. the condition is not one of those that may be selected from thedrop-down menu associated with field 120, then a graphical userinterface (GUI) may be provided for entry of a formula identifying thecondition, as illustrated in FIG. 1C. As shown in FIG. 1C, theconditional formatting GUI includes a first field 150 for entry of thetype of condition and a second field 160 for entry of the formula.

While the Microsoft Excel™ approach to defining conditional expressionsmakes the creation of very simple conditions easy, it makes the creationof more complex expressions very difficult. This difficulty stems from anumber of drawbacks associated with the Microsoft Excel approach. First,the condition language that is to be used in defining conditionalexpressions is not described in the graphical user interfaces. The usermust learn this conditional language by trial and error or going to thedocumentation accompanying the software application. In addition, thegraphical user interfaces do not provide any examples that would providea user with guidance on how to create the conditional expression theyare attempting to create. Moreover, there is no guidance provided by thegraphical user interfaces as the user enters their conditionalexpression guiding the user as to how to complete the conditionalexpression. Furthermore, no guidance is provided to the user when theuser enters a conditional expression that has an error as to how toremedy the error. Furthermore, there is no ability in the MicrosoftExcel™ graphical user interfaces for permitting the user to browse thevariables or functions which can be referenced in the conditionalexpression based on the current context of the conditional expression.

In Microsoft Access™, a database application available from MicrosoftCorporation, a different graphical user interface style is used todefine conditions. As shown in FIG. 2, the graphical user interface iscomposed of twenty or more virtual buttons. There is a button 210 forevery type of operator which can be contained in the conditionalexpression (shown in field 220), and three list boxes 230-250 which canbe used to select from a range of variables, fields and functions.

The Microsoft Access™ approach to defining conditional expressions makesboth simple and complex conditions difficult to create. As with theMicrosoft Excel™ approach, the Microsoft Access™ approach also does notprovide any information regarding the conditional language, that is usedto describe a conditional expression, in the graphical user interface.As a result, the user must learn this conditional language by trial anderror or consult the documentation accompanying the softwareapplication. Again, there are not examples in the graphical userinterface to provide assistance to the user in generating theirconditional expression. Furthermore, although there is a list ofvariables and functions that may be selected, there is no guidance withregard to which variables and functions from the lists should beselected. In other words, it is rather easy for a user to generate aconditional expression with errors by selecting the wrong variables andfunctions from the lists since no guidance is given as to whichvariables and functions are most appropriate for the current context ofthe conditional expression.

Thus, it would be beneficial to have an improved apparatus and methodfor providing an interface through which a user may generate aconditional expression and through which guidance may be provided to theuser to aid the user in generating the conditional expression based onthe current context of the conditional expression.

BRIEF SUMMARY OF THE INVENTION

The present invention provides an apparatus, method and computer programproduct for providing a user interface through which a user may generatea conditional expression. This user interface may be implemented in anytype of application that uses conditional expressions including databaseapplications, spreadsheet applications, and the like.

The user interface of the present invention provides guidance to a useras to the proper components of the conditional expression to include inthe conditional expression as the user constructs the conditionalexpression. Thus, as the user completes parts of the conditionalexpression, the guidance that is offered is updated based on the currentcontext of the conditional expression. This guidance may includelistings of variables, attributes and/or functions that are mostappropriate to be entered next in the conditional expression, help text,and the like.

The interface, in accordance with one embodiment, includes a conditionalexpression tree component, an entry suggestion list component, and ahint message component. The hint message component provides the userwith guidance messages instructing the user as to what actions need tobe performed or input needs to be provided with regard to a currentlyselected or modified part of a condition expression in the conditionalexpression tree component. The entry suggestion list component providesthe user with guidance regarding the particular entries that would beappropriate for inclusion in the conditional expression at a positioncurrently being selected or modified by the user in the conditionalexpression tree component of the interface. The conditional expressiontree component of the interface provides a current context of theconditional expression depicted in a hierarchical tree format.

The hierarchical tree format of the conditional expression treecomponent is such that conditional expressions that must be satisfiedtogether are connected using a solid line while conditional expressionsthat may be alternatively satisfied are connected using dotted lines. Inaddition, the Boolean operators “and,” “or,” “not”, etc. may be depictedin accordance with these connections. The conditional expressions arehierarchically depicted as a primary or parent condition with itssub-conditions being indented beneath it. A user may shiftsub-conditions left or right in the conditional expression treecomponent to either create a sub-condition or collapse sub-conditions.

Thus, the present invention provides a graphical user interface throughwhich a user is provided guidance at every stage of a process forgenerating a conditional expression. Guidance is offered in the form ofan entry suggestion list that is dynamically updated based on theselections and input made by the user and one or more hint messagesoutput to the user via a hint message component of the graphical userinterface. In this way, the user is given guidance as to what actionthey must perform with regard to the selected or currently beingmodified part of the conditional expression using the dynamicallyupdated hint message. In addition, the user is given guidance as to whatentries would be appropriate for the selected or currently beingmodified part of the conditional expression using the dynamicallyupdated entry suggestion list. The result is a user interface forgeneration of conditional expressions that is more user friendly,provides greater guidance to users so that less sophisticated users mayuse it with ease, and eliminates the need for the user to learn on atrial-and-error basis the way in which a conditional expression is to bebuilt.

These and other features and advantages of the present invention will bedescribed in, or will become apparent to those of ordinary skill in theart in view of, the following detailed description of the preferredembodiments.

BRIEF DESCRIPTION OF THE SEVERAL VIEWS OF THE DRAWINGS

The novel features believed characteristic of the invention are setforth in the appended claims. The invention itself, however, as well asa preferred mode of use, further objectives and advantages thereof, willbest be understood by reference to the following detailed description ofan illustrative embodiment when read in conjunction with theaccompanying drawings, wherein:

FIG. 1A is an exemplary diagram of a Microsoft Excel™ graphical userinterface for entry of a conditional expression in which two parametervalue fields are provided;

FIG. 1B is an exemplary diagram of a Microsoft Excel™ graphical userinterface for entry of a conditional expression in which one parametervalue field is provided;

FIG. 1C is an exemplary diagram of a Microsoft Excel™ graphical userinterface for entry of a conditional expression in which a formula maybe entered;

FIG. 2 is an exemplary diagram of a Microsoft Access™ graphical userinterface for entry of a conditional expression;

FIG. 3 is an exemplary diagram of a computing device in which aspects ofthe present invention may be implemented;

FIG. 4 is an exemplary block diagram of the primary operationalcomponents of a computing device in which aspects of the presentinvention may be implemented;

FIG. 5 is an exemplary diagram of an initial graphical user interfacefor generating a conditional expression in accordance with one exemplaryembodiment of the present invention;

FIGS. 6A-6D are exemplary diagrams illustrating a process for generatinga conditional expression in accordance with one exemplary embodiment ofthe present invention;

FIG. 7 is an exemplary diagram of a graphical user interface forgenerating a conditional expression in which a complete conditionalexpression has been generated;

FIG. 8 is an exemplary block diagram illustrating the primaryoperational components of a conditional expression engine in accordancewith the present invention; and

FIG. 9 is a flowchart outlining an exemplary operation of the presentinvention when generating a conditional expression.

DETAILED DESCRIPTION OF THE INVENTION

The present invention provides an apparatus, method and computer programproduct for providing a condition builder interface through which a usermay generate conditional expressions. The present invention ispreferably implemented in a data processing environment. This dataprocessing environment may be a single computing device or may be adistributed data processing environment incorporating a plurality ofcomputing devices. FIGS. 3 and 4 are provided as an exemplary dataprocessing environment in which aspects of the present invention may beimplemented. It should be appreciated that FIGS. 3 and 4 are onlyexemplary and are not intended to state or imply any limitation as tothe type of data processing environments in which the present inventionmay be implemented.

With reference now to the figures and in particular with reference toFIG. 3, a pictorial representation of a data processing system in whichthe present invention may be implemented is depicted in accordance witha preferred embodiment of the present invention. A computer 300 isdepicted which includes system unit 302, video display terminal 304,keyboard 306, storage devices 308, which may include floppy drives andother types of permanent and removable storage media, and mouse 310.Additional input devices may be included with personal computer 300,such as, for example, a joystick, touchpad, touch screen, trackball,microphone, and the like. Computer 300 can be implemented using anysuitable computer, such as an IBM eServer computer or IntelliStationcomputer, which are products of International Business MachinesCorporation, located in Armonk, N.Y. Although the depictedrepresentation shows a computer, other embodiments of the presentinvention may be implemented in other types of data processing systems,such as a network computer. Computer 300 also preferably includes agraphical user interface (GUI) that may be implemented by means ofsystems software residing in computer readable media in operation withincomputer 300.

With reference now to FIG. 4, a block diagram of a data processingsystem is shown in which the present invention may be implemented. Dataprocessing system 400 is an example of a computer, such as computer 300in FIG. 3, in which code or instructions implementing the processes ofthe present invention may be located. Data processing system 400 employsa peripheral component interconnect (PCI) local bus architecture.Although the depicted example employs a PCI bus, other bus architecturessuch as Accelerated Graphics Port (AGP) and Industry StandardArchitecture (ISA) may be used. Processor 402 and main memory 404 areconnected to PCI local bus 406 through PCI bridge 408. PCI bridge 408also may include an integrated memory controller and cache memory forprocessor 402. Additional connections to PCI local bus 406 may be madethrough direct component interconnection or through add-in connectors.In the depicted example, local area network (LAN) adapter 410, smallcomputer system interface SCSI host bus adapter 412, and expansion businterface 414 are connected to PCI local bus 406 by direct componentconnection. In contrast, audio adapter 416, graphics adapter 418, andaudio/video adapter 419 are connected to PCI local bus 406 by add-inboards inserted into expansion slots. Expansion bus interface 414provides a connection for a keyboard and mouse adapter 420, modem 422,and additional memory 424. SCSI host bus adapter 212 provides aconnection for hard disk drive 426, tape drive 428, and CD-ROM drive430. Typical PCI local bus implementations will support three or fourPCI expansion slots or add-in connectors.

An operating system runs on processor 402 and is used to coordinate andprovide control of various components within data processing system 400in FIG. 4. The operating system may be a commercially availableoperating system such as Windows XP, which is available from MicrosoftCorporation. An object oriented programming system such as Java may runin conjunction with the operating system and provides calls to theoperating system from Java programs or applications executing on dataprocessing system 400. “Java” is a trademark of Sun Microsystems, Inc.Instructions for the operating system, the object-oriented programmingsystem, and applications or programs are located on storage devices,such as hard disk drive 426, and may be loaded into main memory 404 forexecution by processor 402.

Those of ordinary skill in the art will appreciate that the hardware inFIG. 4 may vary depending on the implementation. Other internal hardwareor peripheral devices, such as flash read-only memory (ROM), equivalentnonvolatile memory, or optical disk drives and the like, may be used inaddition to or in place of the hardware depicted in FIG. 4. Also, theprocesses of the present invention may be applied to a multiprocessordata processing system.

For example, data processing system 400, if optionally configured as anetwork computer, may not include SCSI host bus adapter 412, hard diskdrive 426, tape drive 428, and CD-ROM 430. In that case, the computer,to be properly called a client computer, includes some type of networkcommunication interface, such as LAN adapter 410, modem 422, or thelike. As another example, data processing system 400 may be astand-alone system configured to be bootable without relying on sometype of network communication interface, whether or not data processingsystem 400 comprises some type of network communication interface. As afurther example, data processing system 400 may be a personal digitalassistant (PDA), which is configured with ROM and/or flash ROM toprovide non-volatile memory for storing operating system files and/oruser-generated data.

The depicted example in FIG. 4 and above-described examples are notmeant to imply architectural limitations. For example, data processingsystem 400 also may be a notebook computer or hand held computer inaddition to taking the form of a PDA. Data processing system 400 alsomay be a kiosk or a Web appliance.

The processes of the present invention are performed by processor 402using computer implemented instructions, which may be located in amemory such as, for example, main memory 404, memory 424, or in one ormore peripheral devices 426-430.

As mentioned above, the present invention is directed to an improvedapparatus, method and computer program product for providing a conditionexpression building interface. The condition expression buildinginterface of the present invention leads the user through the creationof the conditional expression. The interface of the present inventionprovides a first component that is the condition expression treebuilding component, a second component that is an entry suggestion listfrom which the user may select an entry suggestion to incorporate intothe condition expression tree in the first component, and a thirdcomponent that is a hint area component which provides comments toassist the user based on the current state of the condition expressiontree in the first component. Initially, the user is requested, via theinterface, to select a simple expression type, i.e. a condition. Thesevarious components of the interface are illustrated in FIG. 5.

FIG. 5 is an exemplary diagram of an initial graphical user interfacefor generating a conditional expression in accordance with one exemplaryembodiment of the present invention. As shown in FIG. 5, the conditionexpression tree component 510 of the interface 500 includes aconditional part 512, i.e. the “If” part, and an action part 514, i.e.the “Then” part. A user may enter conditions in the conditional part 514that, when satisfied, result in a user defined action in the action part514 being performed.

Conditions generated by the user in the condition part 512 of thecondition expression tree component 510 are depicted in the conditionexpression tree component 510 as a condition tree, or tree ofconditions. For example, an initial condition may be presented at afirst level, or root level, of the condition tree with subsequentconditions appearing as branches off of the initial condition based ontheir correspondence with the initial condition. More information aboutthe manner in which condition trees are depicted in the conditionalexpression tree component 510 will be provided hereafter with referenceto FIGS. 6A-6D and 7.

To the right of the condition expression tree component 510 is the entrysuggestion list component 520 of the interface 500. The entry suggestionlist component 520 is a context sensitive list of the possible entriesfor a selected part of the condition tree currently existing in thecondition expression tree component 510. The entry suggestion listcomponent 520 is updated dynamically as different parts of the conditiontree present in the condition expression tree component 510 areselected. A user may select an entry suggestion from the entrysuggestion list component 520 in order to incorporate that entrysuggestion into the selected part of the condition tree in the conditionexpression tree component 510.

Below the condition expression tree component 510 is the hint component530 of the interface 500. The hint component 530 provides comments toassist the user in what the user needs to do next to complete aconditional expression using the interface 500. These comments aredynamically updated based on the current state of the conditional treein the condition expression tree component 510 and are geared towardleading the user through the process of generating a conditionalexpression using the interface 500.

For example, as shown in FIG. 5, the part of the condition tree,“Condition . . . ”, has been selected by the user (denoted by thehighlighting of the text). In accordance with this selection, both ofthe entry suggestion list component 520 and the hint component 530 aredynamically updated to provide the necessary assistance to aid the userin generating a conditional expression. For example, entry suggestionlist component 520 is updated to include a list of the possible inputsfor the highlighted, or selected, part of the condition tree in thecondition expression tree component 512.

FIGS. 6A-6D are exemplary diagrams illustrating a process for generatinga conditional expression in accordance with one exemplary embodiment ofthe present invention. As shown in FIG. 6A, initially, the interface 600includes a condition expression tree component 610 in which both thecondition component 612 and the action component 614 are set to generictext tokens “condition” and “action” so that the user may select thesetext tokens and be provided with corresponding lists of possible entriesfor that token in the entry suggestion list component 620. The“condition” and “action” tokens may be represented in the form of ahyperlink, for example. The hyperlink indicates that the “condition”token and “action” token are merely place holders and that the usershould select these tokens to define these portions of the conditionalexpression. If the user selects one of these hyperlink tokens, acorresponding suggestion list is generated to show possible replacementsfor the place holder, i.e. the suggestion list component 620 is updatedwith entries for replacement of the selected hyperlink token.

The replacement entries for the selected hyperlink token may themselvesinclude hyperlink tokens that are to be selected by the user fordefining the conditional expression. For example, if the suggestion listentry “var1 is equal to var2,” is selected to replace the “condition”hyperlink token, the form “Select Variable . . . ==Select Variable . . .,” is used to replace the “condition” hyperlink token with the “SelectVariable . . . ” parts being hyperlink tokens themselves. Once again,the hyperlink tokens are place holders that the user should select inorder to complete the conditional expression.

As will be discussed in greater detail hereafter, each time a userselects a token in the condition expression tree component 610, thepresent invention searches a reference set of data to identify thoseentries in the reference set of data that have a same type as theselected token. This reference set of data may be dynamically generatedby analyzing the data within an application with which the presentinvention is associated or may be statically present as an establisheddatabase of entries prior to the use of the present invention togenerate a conditional expression.

The matching entries in the reference set of data are then provided inthe entry suggestion list component 620 and may be selected by the userin order to modify the currently selected token in the conditionexpression tree component 610. For example, if the user selects thetoken “condition” in the condition expression tree component 610, atoken type associated with the “condition” token is identified and usedto search a condition tree entry reference set of data, having possiblecondition tree entries stored therein, to identify those entriescorresponding to the token type. In the depicted example, the“condition” token has a type that is a “condition expression” type, i.e.a token that identifies the type of conditional expression that is beingcreated. As a result, entries in the condition tree entry reference setof data that represent condition expression types are retrieved. Asdepicted, these may include, for example, “var1 is equals to var2,”“var1 is not equals to var2,” “var1 is greater than var2,” and the like.

In addition, the selection of a token, such as the “condition” token, inthe condition expression tree component 610 of the interface 600 alsocauses a lookup of hint messages from a hint message reference set ofdata based on the token type of the selected token. The lookup in thehint message reference set of data attempts to provide hint messagescorresponding to the selected token type. Thus, for example, if the userselects the “condition” token in the condition expression tree component610 of the interface 600, a hint message, such as “Select a template orvariable from the suggestion list to the right,” corresponding to thetoken type “condition expression type” is retrieved from the hintmessage reference set of data and displayed via the hint component 630of the interface 600. It should be noted that the hint messages may beaudibly output in addition to, or in replacement of, the visual displayof the hint message in the hint component 630. For example, aprerecorded message or voice synthesis mechanism may be used to audiblyoutput the retrieved hint message so that the user may hear the hintmessage via his/her speakers or other audio output device.

The “condition” token illustrated in FIG. 6A is a token that is used torequest that the user select a simple conditional expression type thatis to be the basis for generating the conditional expression. Once theuser selects a simple conditional expression type that most resemblesthe type of conditional expression the user wishes to generate, theselected token, i.e. the “condition” token, is replaced with one or moretokens associated with the selected conditional expression. For example,as illustrated in FIG. 6B, the user may select the “var1 is equals tovar2” conditional expression type from the entry suggestion listcomponent 620 resulting in the “condition” token being replaced with theseries of tokens “Select Variable,” “==,” and “Select Variable.” Theorder of the tokens and the particular tokens themselves are establishedas being representative of the selected entry from the entry suggestionlist component 620. For example, the series “Select Variable==SelectVariable” is equivalent to the selected entry “var1 is equals to var2”from the entry suggestion list component 620.

Thus, as shown in FIG. 6B, the result of selecting the “var1 is equalsto var2” entry from the entry suggestion list component 620 is thereplacement of the “condition” token with the series of tokens “SelectVariable,” “==,” and “Select Variable.” The “Select Variable” token isused to request that the user define the values or variables within thecondition expression. When a user selects the “Select Variable” token,there is again a lookup in the condition tree entry reference set ofdata so that entries having a token type corresponding to the token typeof the token “Select Variable” are used to populate an updated versionof the entry suggestion list component 620.

In addition to updating the entry suggestion list component 620 inresponse to the selection of the token “Select Variable,” the presentinvention also updates the hint component 630 by performing a lookup ofthe token type of the token “Select Variable” in a hint messagereference set of data to identify a hint message that has a token typeof the same type of the “Select Variable” token. Thus, for example, inresponse to the user selecting the token “Select Variable” the entrysuggestion list component 620 and the hint component 630 are updated. Inthis way, the user is provided with guidance as to what they need to dowith regard to the selected token, e.g., the hint message “Select avariable or attribute from the suggestion list” may be presented. Theuser is further guided as to the entries that may be used with theselected token in the condition component 612.

As shown in FIG. 6C, the entry suggestion list component 620 provides alist of possible entries into the part of the condition selected by theuser in the condition component 612 of the condition expression treecomponent 610. The entry suggestion list may take the form of ahierarchical tree in which some variables may be part of variable groupsor variables may have selectable attributes that are represented aschild nodes of the variable node in the hierarchical tree. For example,as shown in FIG. 6C, the attribute “total:int” is a child noderepresenting an attribute of a variable node “myHand:BR_Blackjack.”

Also shown in FIG. 6C, the token “Select Variable” has been replaced bythe variable/attribute “myHand.total” in response to the user selectingthe attribute child node “total:int” in the entry suggestion listcomponent 620 of the interface 600. Having selected thisvariable/attribute, the user may then select the operator token in thecondition component 612 as illustrated in FIG. 6D. In response toselecting the operator token in the condition component 612, the entrysuggestion list component 620 is updated to include the possibleoperators that may be used to replace the operator token in thecondition component 612.

The particular operators that are used to populate the entry suggestionlist component 620 may be determined not only upon the operator tokentype but also upon the entire context of the condition expression in thecondition expression component 612 in its current state. Thus, forexample, the operators that are listed in the entry suggestion listcomponent 620 may be specific to the type of operators that may be usedwith the variable “myHand.total.” This may include all of the possibleoperators matching the operator token type or may be a subset of all ofthe operators that are specifically determined to be appropriate for thetoken type of the variable “myHand.total.”

In a preferred embodiment, in situations where the selection in thecondition tree is not a placeholder, the subset of the condition to theleft of the cursor in the condition tree is used to determine thecontent of the suggestion list. In particular, the content is analyzedaccording to the grammar of the condition language and every possiblecompletion for that subset to the left of the cursor is enumerated. Thisyields a set of token types. The set of token types is then used tobuild a list of variables, functions, methods or operators which havethe same type. These will appear in the suggestion list component of theinterface.

Thus, as the condition expression is created, the token types of each ofthe parts of the condition expression that have already been selectedprior to the current token are used to identify the entries that shouldbe used to populate the entry suggestion list component 620. In thisway, the entry suggestion list component 620 is made to be contextsensitive and may have different sets of entries depending on theparticular context of the condition expression currently being edited inthe condition expression component 612 of the condition expression treecomponent 610 of the interface 600.

In addition to selecting entries from the entry suggestion listcomponent 620, the present invention permits the user to also manuallyenter condition entries using a keyboard or other input device. Thus,the entry suggestion list component 620 and the hint component 630 areboth provided as aids to the user but do not limit the user as to themanner by which the user may define a condition or the resulting action.This of course permits the user to make mistakes as to the creation of aconditional expression. These mistakes may be identified to the user viathe hint component 630 and/or highlighting or otherwise identifying themistaken part of the condition expression.

Mistakes may be identified by analyzing the input provided by the userin the condition component 612 and verifying that it conforms to theallowable grammar for a conditional expression. This grammar is areflection of the condition language, which may be Java, C++, or otherprogramming languages. Syntactic and semantic validation is performed toensure that the condition is well formed. For example, in a conditionexpression such as “x+5==y,” it is verified that the left hand side andthe right hand side of the Boolean operation are type compatible.

The process shown in FIGS. 6A-6D may be repeated for each token in thecondition component 612 and the action component 614 of the conditionexpression tree component 610 of the interface 600. In this way,guidance is given at each step of the process of creating a conditionexpression using the interface 600.

FIG. 7 is an exemplary diagram of a graphical user interface forgenerating a conditional expression in which a complete conditionalexpression has been generated. As shown in FIG. 7, by repeating theprocess described above with regard to each token in the conditioncomponent 612 of the condition expression tree component 610 of theinterface 600, a simple or complex conditional expression may begenerated. In addition, the process described above may be used todefine a simply or complex action by selecting tokens and entries forthe action component 614.

As shown in FIG. 7, the conditional expression may be complex and mayinclude a plurality of Boolean expressions in addition to variables,attributes, values and operators. The Boolean expressions, e.g., “and,”“or,” “not,” etc., are illustrated in a tree like fashion. The tree-likenotation used in the interface 600 emphasizes the verbal nature of thecondition and augments it with graphical lines to clarify therelationship between conditions and sub-conditions.

For example, “and” Boolean expressions are illustrated as beingsub-conditions of their parent condition using a dark graphical lineconnecting the parent condition to the child condition. The Boolean “or”expressions are illustrated as dotted lines linking the two or morealternative conditions and the parent condition. The Boolean expressions“and” and “or” are included in the depicted conditional expression treeand are highlighted, such as through bolding, different color font,background highlighting, etc., to bring the user's attention to thesechild conditions of the parent condition.

In the depicted example, the parent condition“app.mortgageValue<app.salary*40/100” is denoted condition “A,” thechild condition “app.yearsEmployed>+3” is denoted condition “B,” and thecondition “app.creditRating==app.GOLD_RATING” is denoted condition “C.”As shown in FIG. 7, mortgage approval is granted, i.e. the actionappearing after the “Then” tag is performed, if condition A and eitherof condition B or condition C are satisfied. There is a grouping betweenconditions B and C and another grouping between conditions A, B and C.The AND grouping is displayed using a solid line to emphasize that bothconditions must be true. The OR grouping is displayed using a dottedline to emphasize that one or the other must be true.

Although the condition expression tree in the condition expression treecomponent 610 of the interface 600 looks like a tree, the user caninteract with the tree as if it were simple text. The user may simplyclick on a part of the tree and start typing. Alternatively, the usercan treat the tree as a bulleted list such that the user may select asingle line and shift it to the right to thereby create a new branch ofthe condition expression tree automatically. For example, if the token“Condition . . . ” in FIG. 6A were shifted to the right, the resultwould as follows:

In addition, more than one line of the tree may be selected and shiftedto the left, resulting in the collapse of a branch of the conditionexpression tree. Thus, for example, if the “or” conditions in FIG. 7were selected and shifted left, the result would be as follows:

A new sub-condition may be added to an existing condition expressiontree by either going to the end of a line in the existing conditionexpression tree and pressing “Enter” or by entering/selecting a Booleanoperator such as “and,” “or,” etc., manually or from the entrysuggestion list component 620. In each case, a new sub-condition isgenerated below the current line of the condition expression tree.

FIG. 8 is an exemplary block diagram illustrating the primaryoperational components of a conditional expression engine in accordancewith the present invention. It should be appreciated that the elementsshown in FIG. 8 may be implemented in hardware, software or anycombination of hardware and software. In a preferred embodiment, theelements in FIG. 8 are implemented as software instructions executed byone or more processing devices on one or more computing devices.

As shown in FIG. 8, the conditional expression engine 800 includes acontroller 810, an interface 820, an entry suggestion database 830, agraphical user interface engine 840, a hint message database 850, anentry suggestion list generation engine 860, an error detection engine870, and a hint message generation engine 880. The elements 810-880 arein communication with one another via the control/data signal bus 890.Although a bus architecture is shown in FIG. 8, the present invention isnot limited to such and any architecture that facilitates thecommunication of control/data signals between the elements 810-880 maybe used without departing from the spirit and scope of the presentinvention.

While the depicted example embodiment of the present invention will bedescribed in terms of “databases” it should be appreciated that thepresent invention is not limited to such. Rather, the present inventionoperates on reference sets of data that are indicative of the possiblecondition entries and hint messages that may be used to generate aconditional expression. These reference sets of data may be generated,for example, dynamically by analyzing the data within an applicationwith which the conditional expression engine 800 is associated, usinganalyzing code and computer memory, to thereby build reference sets ofdata in computer memory when needed. Thus, the databases in FIG. 8 areonly meant to be illustrative of the reference sets of data that may beused to perform dynamic modification of the entry suggestion list andhint message components of the interface of the present invention. Thesereference sets may be generated dynamically or may be established as adatabase prior to use of the interface of the present invention togenerate a conditional expression.

The controller 810 controls the overall operation of the conditionalexpression engine 800 and orchestrates the operation of the otherelements 820-880. The interface 820 provides a communication interfacethrough which the conditional expression engine 800 may output generatedgraphical user interfaces to be presented to the user and receive inputfrom the user.

In response to receiving a user input via the interface 820 indicatingthat the user wishes to generate a conditional expression, thecontroller 810 instructs the graphical user interface engine 840 togenerate an initial conditional expression tree interface for use by theuser. The generation of the initial conditional expression treeinterface may include using the entry suggestion list generation engine860 and the hint message generation engine 880 to generate an entrysuggestion list and hint message corresponding to the initialconditional expression tree interface. This initial conditionalexpression tree interface may take the form of FIG. 6A, for example.

The controller 810 then monitors for further user input indicatingselections or input to the initial conditional expression treeinterface. In response to receiving a user input or selection, thecontroller 810 determines the token in the initial conditionalexpression tree interface that is being modified or selected. Anidentifier of the token and the taken type are provided to the entrysuggestion list generation engine 860 and the hint message generationengine 880. The entry suggestion list generation engine 860 looks up thetoken type in the entry suggestion database 830 and identifies thoseentries, and any child entries of these entries, in the database 830that have the same token type. These entries are compiled into a list.The list of entries, and their child entries, that match the token typeof the token being modified or selected is then provided to thegraphical user interface engine 840 for updating an entry suggestionlist in the initial conditional expression tree interface. Similarly,the hint message generation engine 880 performs a lookup in the hintmessage database 850 based on the token type to identify a hint messagecorresponding to the token type.

The hint message generation engine 880 and the entry suggestion listgeneration engine 860 may maintain a listing of the token types ofentries already selected for inclusion in the conditional expression sothat a cumulative list is developed. This cumulative list may be used tomodify, based on established rules, the displayed entry suggestion listand the hint message used in the conditional expression tree so thatthey are particular to the cumulative context of the conditionalexpression. Thus, if the user has selected or input a variable X, and avalue Y, then when the user selects an operator token and wishes toobtain an entry suggestion list and hint message for the selectedoperator token, the entry suggestion list and hint message may be aparticular entry suggestion list and hint message for an operator tokentype between a variable having the attributes of variable X and a valuehaving the attributes of the value Y.

The error detection engine 870 constantly monitors the creation processof the conditional expression to determine if the inputs and selectionsmade by the user result in a problem with the conditional grammar of theconditional expression being generated. As mentioned previously, one wayin which such grammatical errors may be determined is to match a formatof a selected part of the conditional expression or an inputted part ofthe conditional expression against the entry suggestion list for thetoken that was modified in that part of the conditional expression todetermine if the format matches any of the suggested entries. If not, anerror may be determined to exist.

If there is a detected problem the error detection engine 870 identifiesthe error and instructs the graphical user interface engine 840 toupdate the graphical user interface to accentuate the position of theerror. This may involve highlighting the part of the conditionalexpression where the error has been found, outputting a message, such asvia the hint message component of the interface, indicating the error,audibly presenting an error message or sound, or the like.

The above operations by the various elements 810-880 are performedrepeatedly until the conditional expression is completed. The aboveoperations may further be performed each time a new conditionalexpression is to be generated by the user. The conditional expressiontree interface engine may further be integrated into an application, maybe used to aid in generating program code, or the like.

FIG. 9 is a flowchart outlining an exemplary operation of the presentinvention when generating a conditional expression. It will beunderstood that each block of the flowchart illustration, andcombinations of blocks in the flowchart illustration, can be implementedby computer program instructions. These computer program instructionsmay be provided to a processor or other programmable data processingapparatus to produce a machine, such that the instructions which executeon the processor or other programmable data processing apparatus createmeans for implementing the functions specified in the flowchart block orblocks. These computer program instructions may also be stored in acomputer-readable memory or storage medium that can direct a processoror other programmable data processing apparatus to function in aparticular manner, such that the instructions stored in thecomputer-readable memory or storage medium produce an article ofmanufacture including instruction means which implement the functionsspecified in the flowchart block or blocks.

Accordingly, blocks of the flowchart illustration support combinationsof means for performing the specified functions, combinations of stepsfor performing the specified functions and program instruction means forperforming the specified functions. It will also be understood that eachblock of the flowchart illustration, and combinations of blocks in theflowchart illustration, can be implemented by special purposehardware-based computer systems which perform the specified functions orsteps, or by combinations of special purpose hardware and computerinstructions.

It should be noted that there are other functions performed using theconditional expression tree interface of the present invention includinginsertion of Boolean operators, modifying the tree notation of theconditional component of the condition expression tree interface basedon shifting of the lines left or right, and the like, that are notincluded in the flowchart shown in FIG. 9. FIG. 9 is intended toillustrate a process of updating the entry suggestion list and hintmessage components of the interface. The other functions that may beperformed by the conditional expression tree interface have beendescribed above and may be performed in parallel with the operationsdepicted in FIG. 9.

As shown in FIG. 9, the operation starts by receiving a request togenerate a conditional expression (step 910). In response, an initialconditional expression tree interface is generated and output (step920). User input to the conditional expression tree interface isreceived (step 930) and the input is analyzed to identify the tokenbeing modified or selected by the user input (step 940). A token type ofthe identified token is then used to perform a lookup of entries in anentry suggestion list database and a hint message database (step 950).The results of the lookup in the entry suggestion list database is alist of suggested entries for the selected or modified token and theresult of the lookup in the hint message database is a hint message forguiding the user in modifying the selected token or token that is beingmodified (step 960).

User input to the entry suggestion list is then received, e.g., aselection of an element from the entry suggestion list is received, andthe condition expression tree is updated (step 970). Thereafter, adetermination is made as to whether the conditional expression has beencompleted (step 980). If not, the operation returns to step 930 and theoperations are repeated. If the conditional expression has beencompleted, the operation terminates.

Thus, the present invention provides a graphical user interface throughwhich a user is provided guidance at every stage of a process forgenerating a conditional expression. Guidance is offered in the form ofan entry suggestion list that is dynamically updated based on theselections and input made by the user and one or more hint messagesoutput to the user via a hint component of the graphical user interface.In this way, the user is given guidance as to what action they mustperform with regard to the selected or currently being modified part ofthe conditional expression using the dynamically updated hint message.In addition, the user is given guidance as to what entries would beappropriate for the selected or currently being modified part of theconditional expression using the dynamically updated entry suggestionlist. The result is a user interface for generation of conditionalexpressions that is more user friendly, provides greater guidance tousers so that less sophisticated users may use it with ease, andeliminates the need for the user to learn on a trial-and-error basis theway in which a conditional expression is to be built.

It is important to note that while the present invention has beendescribed in the context of a fully functioning data processing system,those of ordinary skill in the art will appreciate that the processes ofthe present invention are capable of being distributed in the form of acomputer readable medium of instructions and a variety of forms and thatthe present invention applies equally regardless of the particular typeof signal bearing media actually used to carry out the distribution.Examples of computer readable media include recordable-type media, suchas a floppy disk, a hard disk drive, a RAM, CD-ROMs, DVD-ROMs, andtransmission-type media, such as digital and analog communicationslinks, wired or wireless communications links using transmission forms,such as, for example, radio frequency and light wave transmissions. Thecomputer readable media may take the form of coded formats that aredecoded for actual use in a particular data processing system.

The description of the present invention has been presented for purposesof illustration and description, and is not intended to be exhaustive orlimited to the invention in the form disclosed. Many modifications andvariations will be apparent to those of ordinary skill in the art. Theembodiment was chosen and described in order to best explain theprinciples of the invention, the practical application, and to enableothers of ordinary skill in the art to understand the invention forvarious embodiments with various modifications as are suited to theparticular use contemplated.

1. A method, in a data processing system, for providing an interface for generating a conditional expression for use with a computer application, comprising: generating an initial user interface having a conditional expression component and an entry suggestion list component; receiving user input from a user to the conditional expression component; and dynamically updating the entry suggestion list component based on the user input to the conditional expression component, wherein the updated entry suggestion list component identifies one or more selectable entries for inclusion in the conditional expression at a position in the conditional expression corresponding to the user input.
 2. The method of claim 1, wherein the initial user interface further includes a hint message component, and wherein the method further includes: dynamically updating the hint message component to include a message identifying an action to be performed or an input to be provided by a user in association with the position in the conditional expression corresponding to the user input.
 3. The method of claim 1, wherein the conditional expression component includes one or more tokens for the conditional expression, and wherein the user input is one of a selection of a token in the one or more tokens and a modification of a token in the one or more tokens.
 4. The method of claim 3, wherein the one or more tokens for the conditional expression includes at least one hyperlink token that is selectable by a user, and wherein if the hyperlink token is selected by the user, the entry suggestion list is updated to include entries for replacement of the selected hyperlink token.
 5. The method of claim 1, wherein the entry suggestion list of the initial user interface includes a listing of templates for conditional expressions.
 6. The method of claim 5, wherein at least one template in the listing of templates includes one or more hyperlink tokens selectable by a user, and wherein if a hyperlink token in the at least one template is selected by a user, the entry suggestion list is updated to include entries for replacing the selected hyperlink token.
 7. The method of claim 1, wherein the conditional expression component includes a representation of the conditional expression in a hierarchical tree format.
 8. The method of claim 1, wherein the hierarchical tree format includes conditional expressions that must both be satisfied being depicted as connected by solid lines.
 9. The method of claim 1, wherein the hierarchical tree format includes conditional expressions that may alternatively be satisfied being depicted as connected by dotted lines.
 10. The method of claim 3, wherein dynamically updating the entry suggestion list component based on the user input to the conditional expression component includes: generating a reference set of data identifying possible entries for a conditional expression; determining a token type for a selected token in the one or more tokens for the conditional expression; and matching the token type to data types for entries in the reference set of data; and generating a listing of entries from the reference set of data which have data types that match the token type.
 11. A computer program product in a computer readable medium for providing an interface for generating a conditional expression for use with a computer application, comprising: first instructions for generating an initial user interface having a conditional expression component and an entry suggestion list component; second instructions for receiving user input from a user to the conditional expression component; and third instructions for dynamically updating the entry suggestion list component based on the user input to the conditional expression component, wherein the updated entry suggestion list component identifies one or more selectable entries for inclusion in the conditional expression at a position in the conditional expression corresponding to the user input.
 12. The computer program product of claim 11, wherein the initial user interface further includes a hint message component, and wherein the computer program product further includes: fourth instructions for dynamically updating the hint message component to include a message identifying an action to be performed or an input to be provided by a user in association with the position in the conditional expression corresponding to the user input.
 13. The computer program product of claim 11, wherein the conditional expression component includes one or more tokens for the conditional expression, and wherein the user input is one of a selection of a token in the one or more tokens and a modification of a token in the one or more tokens.
 14. The computer program product of claim 13, wherein the one or more tokens for the conditional expression includes at least one hyperlink token that is selectable by a user, and wherein if the hyperlink token is selected by the user, the entry suggestion list is updated to include entries for replacement of the selected hyperlink token.
 15. The computer program product of claim 11, wherein the entry suggestion list of the initial user interface includes a listing of templates for conditional expressions.
 16. The computer program product of claim 15, wherein at least one template in the listing of templates includes one or more hyperlink tokens selectable by a user, and wherein if a hyperlink token in the at least one template is selected by a user, the entry suggestion list is updated to include entries for replacing the selected hyperlink token.
 17. The computer program product of claim 11, wherein the conditional expression component includes a representation of the conditional expression in a hierarchical tree format.
 18. The computer program product of claim 11, wherein the hierarchical tree format includes conditional expressions that must both be satisfied being depicted as connected by solid lines.
 19. The computer program product of claim 11, wherein the hierarchical tree format includes conditional expressions that may alternatively be satisfied being depicted as connected by dotted lines.
 20. The computer program product of claim 13, wherein the third instructions for dynamically updating the entry suggestion list component based on the user input to the conditional expression component include: instructions for generating a reference set of data identifying possible entries for a conditional expression; instructions for determining a token type for a selected token in the one or more tokens for the conditional expression; and instructions for matching the token type to data types for entries in the reference set of data; and instructions for generating a listing of entries from the reference set of data which have data types that match the token type.
 21. An apparatus for providing an interface for generating a conditional expression for use with a computer application, comprising: means for generating an initial user interface having a conditional expression component and an entry suggestion list component; means for receiving user input from a user to the conditional expression component; and means for dynamically updating the entry suggestion list component based on the user input to the conditional expression component, wherein the updated entry suggestion list component identifies one or more selectable entries for inclusion in the conditional expression at a position in the conditional expression corresponding to the user input. 